CREATE TRIGGER [TR_AS_UPDATE_MASTER_DATA] ON [dbo].[MMS_MASTER_DATA] 
  AFTER UPDATE 
AS
BEGIN
  SET NOCOUNT ON;
  UPDATE [dbo].[MMS_MASTER_DATA] 
  SET update_date = getdate() 
  WHERE id = (SELECT id FROM INSERTED)

END
--DROP TRIGGER [TR_AS_UPDATE_MASTER_DATA];
-- FOR TESTING
select * from MMS_MASTER_DATA;
USE MMS
GO
INSERT INTO MMS_MASTER_DATA VALUES ('TEST', 'TEST_TYPE', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
select * from MMS_MASTER_DATA;
UPDATE MMS_MASTER_DATA SET type = 'TEST_TYPE1' WHERE CODE = 'TEST';
select * from MMS_MASTER_DATA;
DELETE MMS_MASTER_DATA WHERE ID = 21;
select * from MMS_MASTER_DATA;